Managing Finished Good Item Masters

Finished Goods are the highest level of the Bills of Materials, created from raw materials and/or subassemblies. Finished Goods may be both purchased and sold. Most items are set up through the initial DEACOM implementation, but new items can be added at any time via Inventory > Item Master. For various methods of designing a part numbering system and information on how to create parts in general, refer to Designing a Part Numbering System and Creating Parts.

Configuration

Creating parts

In almost all cases, parts numbers, or more appropriately item master records, are imported into the system automatically by members of the Implementation team during the initial implementation phase of installing DEACOM. At this point, individual part numbers are added or modified by users on an as needed basis. The most effective way to create new parts is to copy an existing part that matches the part to be created as close as possible. Some additional configuration may be required outside of what was done during the import process. Examples include creating additional item Categories, Sub-Categories, and Item Search field selection. These items are especially important when it comes to Configuring Sales Pricing Rules.

Process

To create a new Finished Good or modify an existing one:

  1. Navigate to Inventory > Item Master.
  2. Select "Finished Goods" from the "Item Type" pick list, fill in the rest of the pre-filter as desired, then click "View".
    1. If editing an existing Part, select it and click "Modify", make the desired changes, and skip to the last step.
    2. If creating a new Part, click "New".
  3. The item header holds the Part Number, Description, Stock Unit and Stock Pricing Unit.
  4. On the General 1 tab:
    1. Select a Category and Sub-Category from the pick lists.
    2. Designate the Default Location Type and Default Location, if using this feature.
    3. Define Scrap and Over-issue values. Refer to Utilizing Scrap Factors or more information on how this is used.
    4. Define the default Order Type that should be used when entering new Sales Order by selecting an option from the Order Type pick list.
    5. Define which field on the Item Master should be used to generate the default Purchase Order price by selecting an option from the PO Price Type pick list.
    6. Specify if inventory for this item should be allowed to go negative and how often it should be counted via Cycle Counts.
    7. Select an Item Type of "Finished Goods".
  5. On the General 2 tab:
    1. Enter text in the "SO Pop-up Notes" and "PO Pop-up Notes" fields if a prompt should appear when entering a Sales or Purchase Order for this item.
    2. Define the Shelf Life that this item is good for along with a Default Finish Quantity, if one exists.
    3. If this item belongs to a Tax Exempt Group, assign one now. For more information refer to the Tax Regions and Exemptions on Sales and Purchase Orders section of the Managing Customers Using Tax Regions page.
    4. If a limit should be placed on the amount that can issued to a Job or received on a Purchase Order, define the percent(s) and check off the appropriate "Enforce Limit" flag(s).
  6. On the MRP tab:
    1. Enter values in the "Lead Time" and "QC Lead Time" fields. These items represent the time, in calendar days, required to receive and perform QC tests on an item. "Safety Days" is also a useful field, which is used to calculate a Job's planned finish date.
      1. Notes: 1. Safety Days are added to QC Lead Times when using MRP. 2.
        1. Beginning in version 16.05.036, QC Lead Time can be excluded from Time-Phased MRP calculations via the QC Lead Time pre-filter option in MRP.
    2. Define other data as necessary if this item will be used in conjunction with the MRP feature.
  7. On the Costs tab, enter values for Materials Burden and Freight costs, current and future. All other costs will be determined by the costs of the parts that comprise this Finished Good.
  8. On the Costs 2 tab, define the List Sale Price and default Purchase Price.
  9. Navigate to the Properties tab and check off the appropriate flags. Examples of which flags should be marked for finished goods is included in the Properties Tab Templates section of the Item Master page.
  10. If User Fields are being utilized for this item, enter the proper values and make selections from the Item Search 1-5 fields on the User Fields tab.
  11. On the Accounts tab, define all accounts that this part will be affecting during Purchasing and Sales.
  12. If this part will have Facility-specific information associated with it, navigate to the Facilities tab, click "Add", fill in the desired fields, then save and exit back to the Edit Item Master form.
  13. On the Units tab, enter or verify the following Units of Measure: Sales Unit, Purchase Unit, Count Unit. Other units may be entered as needed.
  14. If Calculations, Features, and/or Substitutes will be used for this Part, navigate to the appropriate tab and enter the necessary information. For more information, refer to the Configuring Feature Parts, Building Sales Orders with the Product Configurator, and Utilizing Substitutes in Production pages.
  15. Define UPC Numbers and Descriptions, if utilized.
  16. Assign the default SDS and COA forms on the Part Forms tab. For information on how to configure these forms, refer to the Modifying SDS and Managing Part Forms pages.
  17. If the creation of this Part requires a Work Flow, add it on the Work Flow tab. For more information, refer to the Configuring Work Flows page.
  18. If QC testing will be performed on this Part, on the QC/Stability Test tab:
    1. Click "Add" to assign a new QC Group and Frequency.
    2. Click "Next" if the Part should belong to more than one QC Group, otherwise save and exit back to the Edit Item Master form.
    3. If this Part will be received and QC testing will be performed at a later date, the "Receive to At-Risk" flag may be checked. For more information on this option, refer to the Managing At-Risk Inventory page.
  19. Once all information has been entered, click "Save" and "Exit" to commit the changes and close the form.